IsBusinessDay (date)

Basic and Crystal syntax.

Note:    This function assumes a Business Calendar has been set up for your system. Currently, the Business Calendar is only supported in Seagate Info but not in Crystal Reports. If you are using this function in Crystal Reports, or if you have not specified a Business Calendar for your Seagate Info system, this function assumes everyday is a business day.

Arguments

(date) is a Date value.

Returns

Boolean value

Action

Evaluates the date specified in the argument, and returns TRUE if the Date value falls on a business day.

Typical Uses

You can use this function in a record selection formula to limit the report to records for business days, or to records that are not for business days.

Examples

The following examples are applicable to both Basic and Crystal syntax:

IsBusinessDay({Customer.ORDER DATE})

Returns TRUE, where {Customer.ORDER DATE} has a value of 10/14/98, and is specified to be a business day according the Business Calendar for your system.

IsBusinessDay({Customer.ORDER DATE})

Returns FALSE, where {Customer.ORDER DATE} has a value of 10/18/98 which is a Sunday, and is specified to be a non-business day according to the Business Calendar for your system.

Comments

Currently, this function only accepts a date but not a dateTime field as an argument.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com